Felix Zumstein
Python for Excel
A Modern Environment for Automation and Data Analysis
DATA PYTHON
“This book explains how you can integrate Python into Excel and free yourself from the inevitable disaster of huge workbooks, thousands of formulas, and ugly VBA hacks.
Python for Excel
is probably the single most useful book on Excel that I have read and an absolute must-read for any advanced Excel user.”
—Andreas F. Clenow
CIO, Acies Asset Management, and author of international best-sellers
Following the Trend
,
Stocks on the Move
, and
Trading Evolved
Python for Excel
ISBN: 978-1-492-08100-5
US $59.99 CAN $79.99
Twitter: @oreillymediafacebook.com/oreillyWhile Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language. In fact, it’s the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein—creator of xlwings, a popular open source package for automating Excel with Python—shows experienced Excel users how to integrate these two worlds efficiently.Excel has added quite a few new capabilities over the past couple of years, but its automation language, VBA, stopped evolving a long time ago. Many Excel power users have already adopted Python for daily automation tasks. This guide gets you started.
•
Use Python without extensive programming knowledge
•
Get started with modern tools, including Jupyter notebooks and Visual Studio Code
•
Use pandas to acquire, clean, and analyze data and replace typical Excel calculations
•
Automate tedious tasks like consolidation of Excel workbooks and production of Excel reports
•
Use xlwings to build interactive Excel tools that use Python as a calculation engine
•
Connect Excel to databases and CSV files and fetch data from the internet using Python code
•
Use Python as a single tool to replace VBA, Power Query, and Power Pivot
Felix Zumstein
is creator and maintainer of xlwings, a popular open source package that allows the automation of Excel with Python on Windows and macOS. As CEO of xltrail, a version control system for Excel files, he’s gained deep insight into the typical use cases and issues with Excel across various industries.
Praise for
Python for Excel
What can Python do for Excel? If you’ve ever dealt with unexpected workbook crashes,broken calculations, and tedious manual processes, you’ll want to find out. Python forExcel is a comprehensive and succinct overview to getting started with Python as aspreadsheet user, and building powerful data products using both. Don’t let the fear of learning to code keep you away: Felix provides an exceptional foundation for learningPython that even experienced programmers could benefit from. Moreover, he frames thisinformation in a way that is quickly accessible and applicable to you as an Excel user. Youcan quickly tell reading this book that it was written by someone with years of experienceteaching and working with clients on how to use Excel to its fullest extent with the help of Python programming. Felix is uniquely suited to show you the possibilities of learningPython for Excel; I hope you enjoy the master class as much as I did.
—George Mount, Founder, Stringfest Analytics
Python is the natural progression from Excel and it’s tempting to simply discard Excelall together. Tempting, but hardly realistic. Excel is here, and here to stay, both in thecorporate world and as a useful desktop tool at home and in the office. This book provides the much needed bridge between these two worlds. It explains how you canintegrate Python into Excel and free yourself from the inevitable disaster of hugeworkbooks, thousands of formulas, and ugly VBA hacks.
Python for Excel
is probably the single most useful book on Excel that I have read and an absolute must-read forany advanced Excel user. A highly recommended book!
—Andreas F. Clenow, CIO Acies Asset Management and author of international best-sellers
Following the Trend
,
Stocks on the Move
,and
Trading Evolved
Excel remains a cornerstone tool of the financial world, but a vast amount of these Excelapplications are an irresponsible mess. This book does an excellent job of showing youhow to build better, more robust applications with the help of xlwings.
—Werner Brönnimann, Derivatives and DeFi practitioner and cofounder, Ubinetic AG
Excel and Python are two of the most important tools in the Business Analytics toolbox,and together they are far greater than the sum of their parts. In this book, Felix Zumsteinlays out his unparalleled mastery of the many ways to connect Python and Excel usingopen source, cross-platform solutions. It will be an invaluable tool for business analystsand data scientists alike, and any Python user looking to harness thepower of Excel in their code.
—Daniel Guetta, Associate Professor of Professional Practice and Director of the Business Analytics Initiative at ColumbiaBusiness School and coauthor of
Python for MBAs
